PUBLIC MARKS from "Xavier Lacot" with tag sql

Picok stands for Personal Information Cockpit. It's an open source software package, aimed at enableing users to build their personal information dashboards. The users content is loaded into small draggable boxes, so called portlets, and layed out in a tabbed column-based interface. There are a quite few standard portlets shipped with Picok, but since it is an open system, maintainers of picok installations can easily create portlets of their own. Picok is written in PHP 5, uses the Yahoo User Interface Library and Zend Framework Components and supports MySQL, Microsoft SQL Server, IBM Lotus Notes and is ready to be integrated into your corporate intranet, website or community platform as well.

Sphinx is a standalone search engine, meant to provide fast, size-efficient and relevant fulltext search functions to other applications. Sphinx was specially designed to integrate well with SQL databases and scripting languages. Currently built-in data sources support fetching data either via direct connection to MySQL or PostgreSQL, or using XML pipe mechanism (a pipe to indexer in special XML-based format which Sphinx recognizes).

...the most comprehensive API collection on the web

As is well known, caching the results of database queries can dramatically improve script execution time and minimize the load on the database server. This technique can be especially effective if the data you are dealing with is quite static. This is because many data requests to a remote database may be eventually satisfied from the local cache, thus avoiding the need to make a connection to the database, execute the query, and fetch the results.